/*
 Navicat Premium Data Transfer

 Source Server         : ycdb
 Source Server Type    : MySQL
 Source Server Version : 50710
 Source Host           : localhost
 Source Database       : test

 Target Server Type    : MySQL
 Target Server Version : 50710
 File Encoding         : utf-8

 Date: 08/19/2016 00:12:09 AM
*/

SET NAMES utf8;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
--  Table structure for `goods`
-- ----------------------------
DROP TABLE IF EXISTS `goods`;
CREATE TABLE `goods` (
  `name` varchar(255) NOT NULL,
  `id` int(11) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `goods`
-- ----------------------------
BEGIN;
INSERT INTO `goods` VALUES ('SH-82', '1'), ('AM-21', '2'), ('AH-22', '3'), ('BW-31', '4');
COMMIT;

-- ----------------------------
--  Table structure for `in`
-- ----------------------------
DROP TABLE IF EXISTS `in`;
CREATE TABLE `in` (
  `inID` varchar(10) NOT NULL,
  `saler` int(11) DEFAULT NULL,
  `creater` int(11) DEFAULT NULL,
  `createTime` varchar(30) NOT NULL,
  `count` varchar(10) NOT NULL,
  `isfinish` varchar(10) NOT NULL,
  `id` int(11) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `in`
-- ----------------------------
BEGIN;
INSERT INTO `in` VALUES ('IN2016123', '1', '2', '2016-08-16 13:21:17', '23', '0', '1'), ('IN2016213', '2', '4', '2016-08-17 13:25:17', '12', '0', '2'), ('IN2016578', '1', '3', '2016-08-18 16:21:17', '42', '0', '3'), ('IN2016976', '3', '1', '2016-08-19 21:21:17', '11', '0', '4'), ('IN2016158', '4', '2', '2016-08-19 23:21:17', '23', '1', '5');
COMMIT;

-- ----------------------------
--  Table structure for `indetail`
-- ----------------------------
DROP TABLE IF EXISTS `indetail`;
CREATE TABLE `indetail` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `inID` varchar(10) NOT NULL,
  `goodsId` int(11) DEFAULT NULL,
  `createrId` int(11) DEFAULT NULL,
  `createTime` varchar(30) NOT NULL,
  `count` int(10) NOT NULL,
  `leftcount` int(10) DEFAULT NULL,
  `postion` varchar(30) DEFAULT NULL,
  `isfinish` varchar(10) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `indetail`
-- ----------------------------
BEGIN;
INSERT INTO `indetail` VALUES ('1', 'IN2016123', '1', '2', '2016-08-16 13:21:17', '23', '10', '位置A-21', '1'), ('2', 'IN2016123', '3', '2', '2016-08-16 13:21:17', '223', '32', '位置22', '1'), ('3', 'IN2016123', '8', '1', '2016-08-16 13:21:17', '43', '32', '位置13', '1'), ('4', 'IN2016123', '4', '3', '2016-08-16 13:21:17', '23', '23', '位置A21', '0'), ('5', 'IN2016123', '2', '5', '2016-08-16 13:21:17', '12', '12', '位置Rddf', '1'), ('6', 'IN2016123', '1', '2', '2016-08-16 13:21:17', '22', '22', '位置D-32', '0'), ('7', 'IN2016123', '3', '4', '2016-08-16 13:21:17', '123', '123', '位置B-32', '0'), ('8', 'IN2016123', '1', '1', '2016-08-16 13:21:17', '23', '21', '位置X03', '1');
COMMIT;

-- ----------------------------
--  Table structure for `tb_in`
-- ----------------------------
DROP TABLE IF EXISTS `tb_in`;
CREATE TABLE `tb_in` (
  `inID` varchar(10) NOT NULL,
  `saler` int(11) DEFAULT NULL,
  `creater` int(11) DEFAULT NULL,
  `createTime` varchar(30) NOT NULL,
  `count` varchar(10) NOT NULL,
  `isfinish` varchar(10) NOT NULL,
  `id` int(11) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `tb_in`
-- ----------------------------
BEGIN;
INSERT INTO `tb_in` VALUES ('IN2016123', '1', '2', '2016-08-16 13:21:17', '23', '0', '1'), ('IN2016213', '2', '4', '2016-08-17 13:25:17', '12', '0', '2'), ('IN2016578', '1', '3', '2016-08-18 16:21:17', '42', '0', '3'), ('IN2016976', '3', '1', '2016-08-19 21:21:17', '11', '0', '4'), ('IN2016158', '4', '2', '2016-08-19 23:21:17', '23', '1', '5'), ('inabcdefg', '1', '2', '2016年08月17日23:18:32', '100', '0', '6');
COMMIT;

-- ----------------------------
--  Table structure for `test`
-- ----------------------------
DROP TABLE IF EXISTS `test`;
CREATE TABLE `test` (
  `field1` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `test`
-- ----------------------------
BEGIN;
INSERT INTO `test` VALUES ('/*'), ('Navicat Premium Data Transfer'), (''), ('Source Server         : ycdb'), ('Source Server Type    : MySQL'), ('Source Server Version : 50710'), ('Source Host           : localhost'), ('Source Database       : test'), (''), ('Target Server Type    : MySQL'), ('Target Server Version : 50710'), ('File Encoding         : utf-8'), (''), ('Date: 08/18/2016 00:20:02 AM'), ('*/'), (''), ('SET NAMES utf8;'), ('SET FOREIGN_KEY_CHECKS = 0;'), (''), ('-- ----------------------------'), ('--  Table structure for `goods`'), ('-- ----------------------------'), ('DROP TABLE IF EXISTS `goods`;'), ('CREATE TABLE `goods` ('), ('`name` varchar(255) NOT NULL'), ('`id` int(11) NOT NULL AUTO_INCREMENT'), ('PRIMARY KEY (`id`)'), (') ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;'), (''), ('-- ----------------------------'), ('--  Records of `goods`'), ('-- ----------------------------'), ('BEGIN;'), ('INSERT INTO `goods` VALUES (\'SH-82\''), ('COMMIT;'), (''), ('-- ----------------------------'), ('--  Table structure for `in`'), ('-- ----------------------------'), ('DROP TABLE IF EXISTS `in`;'), ('CREATE TABLE `in` ('), ('`inID` varchar(10) NOT NULL'), ('`saler` int(11) DEFAULT NULL'), ('`creater` int(11) DEFAULT NULL'), ('`createTime` varchar(30) NOT NULL'), ('`count` varchar(10) NOT NULL'), ('`isfinish` varchar(10) NOT NULL'), ('`id` int(11) NOT NULL AUTO_INCREMENT'), ('PRIMARY KEY (`id`)'), (') ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;'), (''), ('-- ----------------------------'), ('--  Records of `in`'), ('-- ----------------------------'), ('BEGIN;'), ('INSERT INTO `in` VALUES (\'IN2016123\''), ('COMMIT;'), (''), ('-- ----------------------------'), ('--  Table structure for `tb_in`'), ('-- ----------------------------'), ('DROP TABLE IF EXISTS `tb_in`;'), ('CREATE TABLE `tb_in` ('), ('`inID` varchar(10) NOT NULL'), ('`saler` int(11) DEFAULT NULL'), ('`creater` int(11) DEFAULT NULL'), ('`createTime` varchar(30) NOT NULL'), ('`count` varchar(10) NOT NULL'), ('`isfinish` varchar(10) NOT NULL'), ('`id` int(11) NOT NULL AUTO_INCREMENT'), ('PRIMARY KEY (`id`)'), (') ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;'), (''), ('-- ----------------------------'), ('--  Records of `tb_in`'), ('-- ----------------------------'), ('BEGIN;'), ('INSERT INTO `tb_in` VALUES (\'IN2016123\''), ('COMMIT;'), (''), ('-- ----------------------------'), ('--  Table structure for `user`'), ('-- ----------------------------'), ('DROP TABLE IF EXISTS `user`;'), ('CREATE TABLE `user` ('), ('`age` int(2) NOT NULL'), ('`name` varchar(255) NOT NULL'), ('`id` int(11) NOT NULL AUTO_INCREMENT'), ('`sex` varchar(10) NOT NULL'), ('PRIMARY KEY (`id`)'), (') ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;'), (''), ('-- ----------------------------'), ('--  Records of `user`'), ('-- ----------------------------'), ('BEGIN;'), ('INSERT INTO `user` VALUES (\'18\''), ('COMMIT;'), (''), ('SET FOREIGN_KEY_CHECKS = 1;');
COMMIT;

-- ----------------------------
--  Table structure for `user`
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
  `age` int(2) NOT NULL,
  `name` varchar(255) NOT NULL,
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `sex` varchar(10) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `user`
-- ----------------------------
BEGIN;
INSERT INTO `user` VALUES ('18', 'jhon', '1', 'male'), ('19', 'tom', '2', 'male'), ('17', 'ros', '3', 'male'), ('20', 'ani', '4', 'wmale');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
